LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

GetGroupMembers.zip

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Bootstrap Editable Table

Editable table with Bootstrap 4, with multiple controls, having: Checkbox for ...

BS3EditableTable.zip